Previous Topic

Next Topic

To purge activity attachments created before a specified date

To delete activity attachments with a timestamp before a specified date, you must modify the Purge old Activity attachments report spec to include a date in the purge script from which you want to delete activity attachments, and then run the purge script.

Note: You must have an authorization level of 8 or higher to modify a report spec.

Note: The FILE_TIMESTAMP date that you modify in the purge activity attachment script refers to the date that displays in the File Date column on the Activity Attachment window for the attachment. The File Date displays the date the attachment was last modified. However, if the attachment has not been modified, the date that displays corresponds to the date the file was created.

  1. Select Utilities> Report Specs to open the Report Specifications window.
  2. Scroll down to the SYSTEM module.
  3. Select the SYSTEM-Purge-Purge old Activity attachments report.
  4. Click Parameters to open the Detail Report Parameters window.
  5. Click Edit.
  6. Using the format YYYYMMDD, modify the FILE_TIMESTAMP value of the Purge old Activity attachments script. In the following example, the script has been modified so that activity attachments with a File Date earlier than October 10, 2002 will be deleted:

    delete Activity_Attach where FILE_TIMESTAMP< '20021010' and ACTIVITY_SEQN> 0 and READ_ONLY=0

  7. Click Save.
  8. Select Utilities> Reports and Queries.
  9. Select Purge from the Report Types scrolling list.
  10. Select Purge Old Activity attachments from the Available Reports scrolling list.
  11. Click Run. A message displays informing you that you should make a backup of your database before running the activity attachment purge utility, and asks if you want to continue running the utility. Click Yes to continue running the utility, or No to cancel.
  12. The Purge old Activity attachments window displays showing the number of attachments that were deleted from the iMIS database.

    Note: In an environment where users are importing activities simultaneously, you must ensure that the users do not attempt to import the same files or run the same queries. To prevent a user from inadvertently affecting records another user is processing, you can limit access to the advanced Activity Importer features so that processing is restricted to records imported by a user's specific session.

See Also

Activity Attachments

To enable the activity attachment feature

Specifying maximum size of activity attachments

Activity Attachment Fields


ASI logo 10.6 Production Release. Updated 2/23/2006 12:01:42 PM
© Copyright by Advanced Solutions International, Inc. All rights reserved.